<%@ page import="java.sql.*,studentportal.*"%>
<html>

<head>
 
<title>New Page 1</title>
</head>

<body background="indtextb.jpg" bgcolor="#FFFFFF" text="#000000" link="#3366CC" vlink="#666666" alink="#996600">

<table border="0" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="100%"><img border="0" src="StdPrtlbanner.jpg" width="846" height="65">&nbsp;</td>
  </tr>
</table>

<table border="0" width="100%">
  <tr>
     <td width="20%">
      <p align="center"><font face="Trebuchet MS, Arial, Helvetica">
	  <a href="FacultyMarkCheck.jsp"><b>Faculty Marks Entry</b></a></font></td>
    
    <td width="20%">
      <p align="center"><a href="Home.html"><b>Home</b></a></td>
  </tr>
</table>
<br/><br/><br/><br/>
<form method="get" action="./FacultyMarkStore.jsp">
<table border="1" align="center">
	<tr>
			<th>SID</th>
			<th>SName</th>
			<th>Sub1</th>
			<th>Sub2</th>
			<th>Sub3</th>
			<th>Sub4</th>
			<th>Sub5</th>
	</tr>
<%
try
{
			String fid=(String)session.getAttribute("FacultyID");
			Connection con=MySQLDriver.getConnection();
			Statement st=con.createStatement();
			String qry="select student_id,student_name from student_master"; 
			//where course_id='"+request.getParameter("CID")+"'";
			System.out.println(qry);
			ResultSet rs=st.executeQuery(qry);
			while(rs.next())
			{
				String sid=rs.getString(1);
				String sname=rs.getString(2);
%>
				<tr>
					<td><input type="hidden" name="sid" value="<%=sid%>"><%=sid%></td>
					<td><input type="hidden" name="sname" value="<%=sname%>"><%=sname%></td>
					<td><input type="text" name="sub1" size="5"></td>
					<td><input type="text" name="sub2" size="5"></td>
					<td><input type="text" name="sub3" size="5"></td>
					<td><input type="text" name="sub4" size="5"></td>
					<td><input type="text" name="sub5" size="5"></td>
				</tr>
<%
			}
}
catch(Exception e)
{
	%>
		<tr>
				<td>	<%="No Students"%></td>
		</tr>
<%

}

%>
	<tr>
      <td width="100%" colspan="7">
        <p align="center" ><input type="submit" value="Submit" name="action" tabindex="2"></td>
    </tr>
	</table>
</form>
</body>

</html>
